package com.jy.mapper.vehicle;

import com.jy.model.M_Vehicle;
import com.jy.model.vehicle.M_Brand;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Mapper
@Component
public interface BrandMapper {

//    @Select("SELECT * FROM M_VEHICLE WHERE VEHICLE_NAME = #{VEHICLE_NAME} ")
//    public List<M_Vehicle> queryVehicleByName(String VEHICLE_NAME);
    @Select("SELECT * FROM M_BRAND ORDER BY BRAND_PY")
    public List<M_Brand> queryAllBrand();

//    @Select("SELECT * FROM M_BRAND WHERE BRAND_NAME like ('%',#{brandName},'%'); ORDER BY BRAND_PY")
//    List<M_Brand> queryAllBrandByName(String brandName);
}
